Forum Discussion
Cell format
Hello all,
I have the formula driven date values in column C. The cells of the column are formatted to show the different forms of dates which begin with “=” and ends with “,” signs.
I want to paste/store the C column values in number or General format not as a text in Column D. I tried my best to accomplish this task but has no luck to succeed in it. Doing so change the data appearance as shown in the example below. Any help in this regard will be greatly appreciated and thank you in advance.
C | D | My desired value in plain number format in column D |
=113022, | 44895 | 113022 |
=112922, | 44894 | 112922 |
=221130, | 44895 | 221130 |
10 Replies
Thank you so much for your response, it still shows the date as mentioned in column D. I want the column C date format to be appear in column D as mentioned in next column "My desired value...". (I can get my desire value by converting the column D's cell as Date Format or as a text, but I want the value in plain Number or General format of the cell as mentioned in the next column "My desired value..." Like capturing the data in column C and pasting it to the column D without "=" and coma signs and without Date format of the cell). Thank you.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
