• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

excel change format of cell

How can i change excel format when i change custom to text it will be decimal how can i fix it
delexcel.png
0
teera
Asked:
teera
  • 2
1 Solution
 
teeraAuthor Commented:
this is the excel file
onea.xlsx
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

can you please explain what you want to achieve? Your question is not clear.

cheers, teylyn
0
 
Rory ArchibaldCommented:
What do you want it to be, exactly? Your data is entered as numbers - are you trying to actually convert them to the displayed text?
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
You could use a formula like

=text(a1,"0-0000-00000-00-0")

then copy the result and use paste special > values
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now