Sally_de_Witt - profile

Sally_de_Witt · Sep 27, 2021

Hello, HELP! Working with a base containing formatted currency fields but when downloading CSV, the resulting import into MS Excel, converts the currency fields to TEXT. Is there a way to override this so that currency remains as a number field? Than...

Sally_de_Witt · Sep 21, 2021

Hello Airtable community I have a formula field which show date as month name only: DATETIME_FORMAT({DELIVERY DATE}, “MMMM”) I wanted to use this field to group each month’s records. Unfortunately, the sort function does not sort chronologically as ...

Sally_de_Witt · Aug 22, 2021

Hello I have converted an Excel spreadsheet into an Airtable base. In excel, I have columns that are formatted to show [month] & [weeknum] based on a date that is entered. Is this possible in Airtable? Kind regards, Sally

Sally_de_Witt · Aug 22, 2021

Hi there, I want to add a formula to result in a date. I have a delivery date column. and I want formula to calculate a date 7weeks (49 days) before the delivery date. I have this working in Excel & numbers, but copying the formula into Airtable does...

Sally_de_Witt · Jul 07, 2021

I love the way Airtable organises data & makes everything visual. Can the software be inked to existing excel files for better integration?

Sally_de_Witt · Sep 28, 2021

Hi Kamille, Thank you! My fields contain text, numbers & multiple select fields in addition to the currency & formula fields: BUT, you have just given me a clue - and I have managed to get it working but updating OS decimal & thousands separators an...

Sally_de_Witt · Sep 28, 2021

Hi Dimitris Nope - returns a #VALUE error Something to do with the decimal I think

Sally_de_Witt · Sep 28, 2021

Hello Dimitris, I have the text: $25.35 I have tried as you have suggested above, but the formula will not work (have changed B3 to be my target cell reference) :frowning:

Sally_de_Witt · Sep 27, 2021

Hello Rebecca. Thanks for he suggestion, BUT converting to a number before downloading the csv, still results in text, not number. Cannot be converted in Excel without retyping. Reads the decimal point as a full stop instead of decimal… For now, will...

Sally_de_Witt · Sep 22, 2021

Thank you so much! This will work fine for my purposes!

User Statistics

User Activity

Csv download converts currency to text

Sort Month name field chronologically instead of alphabetically

Can custom formatting be applied to columns in Airtable?

Creating a formula for [date] subtract [specific number of days]

Can a collection of Excel files saved in OneDrive by linked or synced to Airtable base?

Re: Csv download converts currency to text

Re: Csv download converts currency to text

Re: Csv download converts currency to text

Re: Csv download converts currency to text

Re: Sort Month name field chronologically instead of alphabetically