CODEWITHSUNDEEP
excelexcel-formula
User_powerBI
User_powerBI

Reputation: 73

Number automatically getting converted to date in excel

I have an address in a cell in excel cell. When I pull the field using left(cell,4) in excel it automatically converts it to date and gives me 44142 whereas I want the output as 7-11.

7-11 ROMEO DR

I want the actual value. Also, I have list of 30k addresses for which I want to run the formula. How can I solve it?

Upvotes: 1

Views: 48

Answers (1)

Gangula
Gangula

Reputation: 7254

I'm not able to replicate your issue. But you can add a single quote in your formula to get it treated as a text like below:

="'" & left(cell,4)

Upvotes: 1

Related Questions