Age Dates

[stumann121]

Hello,

Please can you help.

I have exported some data from a website and the Age on the site appears as 4d 8h but when exported onto a spreadsheet this figure is populated as '371272'.

Would anyone know how to change this so it appears as how it does on the site? (4d 8h)

Many Thanks,

S

[samba_ravi]

What is 371272

[cbatrody]

Hi,

Can you provide few more examples please?

[dan4ish]

When Exporting at the Last Step change the data format to Text or Date for that particular Column. Don't keep it General

[stumann121]

Hi there,

Sorry to be so difficult!

On the website the info is appears with the column header Age. Then underneath it each row has the age date of each ticket. So earlier the age was 4d 8h which is 4 days and 8 hours but when i've exported the whole document the Age has changed into numbers. Where it is supposed to say 4d 8h there is now 371272

[stumann121]

Hello!,

I'm afraid that when i have formatted it to text the numbers just move to the left of the cell and in a date format it appears like 03/07/2916, which i wrong :-(